<?php
require_once("../conf/db_connection.php");

$query_truckers = "SELECT * FROM trucker";
$result_truckers = mysql_query($query_truckers) or die("SELECT TRUCKERS ".mysql_error());

while($row_truckers = mysql_fetch_array($result_truckers))
{
	$query_up = "UPDATE truck SET trucker_id='".$row_truckers['id']."' WHERE trucker_code='".$row_truckers['code']."'";
	mysql_query($query_up) or die("UPDATE FAILED ".mysql_error());
}
?>